: This will start a new import run. The following input form is displayed:
Enter the file name (excluding the path) that requires loading. The system defaults to C:\temp for the correct file, but you can change this with the parameters option.
The data loaded from the in-coming file will not be validated as such. Each in-coming record will be validated to ensure that each record has the correct number of fields and that the amount fields contain only numeric characters.
If the filename entered can not be found the following message will be displayed.
Note
The budget codes in the imported file may match existing budget codes on the system, but do not have to. The imported budget details are not directly related to the budgets shown in AFO 243. There are no links between them. The import is purely for convenience as a way of displaying the financial system view of any funding that they are using. Normally the budget codes should "match".
General information:
· ASCII
· tab delimited fields
· <CR> at end of each record
· price: decimal notation is a “dot”
· date notation: yyyymmdd
Record layout
|
Field name |
Type |
Description |
|
Code |
Alphanumeric |
Fund account budget code |
|
Name |
Alphanumeric |
Fund account name |
|
Allocation |
Monetary |
Total fund allocation |
|
Commitment |
Monetary |
Current total outstanding orders committed amount |
|
Expenditure |
Monetary |
Current total received orders spent amount |
|
Extract Date |
Date |
Extraction date for these figures |
|
Notes |
Alphanumeric |
Free format note field |
Note
The login user name and system date will be loaded in addition to the actual data fields taken from the file.
All loaded fiscal data files will be available for display by selecting the the option on the budget summary screen (in AFO 243).
: Select a previous run and then this option to view the details.
From this screen you can print the imported file. The system will switch to the standard form for generating output. This will result in the same a report as choosing the option on the overview screen.
: This will allow access to the export system level parameters. The following input form will be displayed:
Here you can specify the path name for the files to be imported.
· Document control - Change History
|
Version |
Date |
Change description |
Author |
|
|
1.0 |
July 2008 |
Creation |
|
|
|
2.0 |
May 2009 |
added Mapping for standing orders; renumbered chapters |
|
|
|
3.0 |
March 2010 |
New options for Multi-tile orders and Minimum selections, potentials processing |
|
|